﻿<?xml version="1.0" encoding="utf-8" ?>
<tableDefinitions xmlns="http://schemas.microsoft.com/wix/2006/tables">

  <tableDefinition name="BiztalkApplications" createSymbols="yes">
    <columnDefinition name="Id" type="string" length="72" primaryKey="yes" modularize="column"
                      category="identifier" description="Identifier for the Biztalk Application in the package."/>
    <columnDefinition name="Component_" type="string" length="72" modularize="column"
                      keyTable="Component" keyColumn="1" category="identifier"
                      description="Foreign key into the Component table used to determine install state" />    
    <columnDefinition name="ApplicationName" type="string" length="200" modularize="column"
                      description="Application Name in Biztalk" />
    <columnDefinition name="BiztalkManagementInstanceName" type="string" length="0" modularize="property"
                      category="formatted" description="Name of the Biztalk Instance where the Management database is installed." nullable="no" />
    <columnDefinition name="BiztalkManagementDatabaseName" type="string" length="0" modularize="property"
                      category="formatted" description="Name of the Biztalk Management Database." nullable="no" />
    <columnDefinition name="BackupLocation" type="string" length="0" modularize="property"
                      category="formatted" description="Location where the existing application will be backed up." nullable="yes" />
  </tableDefinition>

  <tableDefinition name="BiztalkApplicationResources" createSymbols="yes">
    <columnDefinition name="Id" type="string" length="72" primaryKey="yes" modularize="column" 
                      category="identifier" description="Identifier for the Biztalk Application Resource in the package."/>
    <columnDefinition name="BiztalkApplicationId" type="string" length="72" modularize="column" 
                      category="identifier" description="Identifier for the Biztalk Application in the package." />
    <columnDefinition name="FilePath" type="string" length="0" modularize="property" 
                      category="formatted" description="Path to Biztalk Application Resource File" />
    <columnDefinition name="BiztalkResourceType" type="string" length="0" modularize="property"
                      category="formatted" description="Biztalk Resource Type" />
  </tableDefinition>

  <tableDefinition name="BiztalkApplicationReferences" createSymbols="yes">    
    <columnDefinition name="BiztalkApplicationId" type="string" length="72" modularize="column" primaryKey="yes"
                      category="identifier" description="Identifier for the Biztalk Application in the package." />
    <columnDefinition name="ApplicationName" type="string" length="0" modularize="property" primaryKey="yes"
                      category="formatted" description="Name of Biztalk application to refer." />    
  </tableDefinition>

  <tableDefinition name="BamActivities" createSymbols="yes">
    <columnDefinition name="Id" type="string" length="72" primaryKey="yes" modularize="column"
                      category="identifier"  description="Identifier for the Bam Activity." />

    <columnDefinition name="Component_" type="string" length="72" modularize="column"
                          keyTable="Component" keyColumn="1" category="identifier"
                          description="Foreign key into the Component table used to determine install state" />

    <columnDefinition name="Source" type="string" length="0" modularize="property"
                      category="formatted" description="Bam Activity Xml File " />

    <columnDefinition name="DropOnUninstall" type="string" length="0" modularize="property"
                      category="formatted" description="Values can be true or false or a property to drop the bam while uninstalling" />

    <columnDefinition name="BamInstanceName" type="string" length="0" modularize="property"
                      category="formatted" description="Bam Instance Name" />

    <columnDefinition name="BamDatabaseName" type="string" length="0" modularize="property"
                      category="formatted" description="Bam Database Name" />

    <!--<columnDefinition name="BamArchiveInstanceName" type="string" length="0" modularize="property"
                      category="formatted" description="Bam Archive Instance Name" />

    <columnDefinition name="BamArchiveDatabaseName" type="string" length="0" modularize="property"
                      category="formatted" description="Bam Archive Database Name" />-->

    <columnDefinition name="ActivityWindow" type="string" length="0" modularize="property"
                      category="formatted" description="Activity Window for Archiving" />

    <columnDefinition name="ViewAccessAccounts" type="string" length="0" modularize="property"
                      category="formatted" description="Comma separated list of accounts that need to be given access to the views." />
  </tableDefinition>

  <tableDefinition name="VsDbCmd10" createSymbols="yes">
    <columnDefinition name="Id" type="string" length="72" primaryKey="yes" modularize="column"
                      category="identifier"  description="Identifier for the VsDbCmd." />

    <columnDefinition name="Component_" type="string" length="72" modularize="column"
                          keyTable="Component" keyColumn="1" category="identifier"
                          description="Foreign key into the Component table used to determine install state" />

    <columnDefinition name="ConnectionString" type="string" length="0" modularize="property"
                      category="formatted" description="Connection String of the Target Database" />

    <columnDefinition name="DatabaseName" type="string" length="0" modularize="property"
                      category="formatted" description="Specifies the name of the Target DatabaseName" />

    <columnDefinition name="DatabaseSchemaProvider" type="string" length="0" modularize="property"
                      category="formatted" description="Target Database Schema Provider" />

    <columnDefinition name="DeploymentConfigurationFile" type="string" length="0" modularize="property"
                      category="formatted" description="Specifies the .sqldeployment file that you want to use when you deploy." />

    <columnDefinition name="ModelFile" type="string" length="0" modularize="property"
                      category="formatted" description="Specifies the name of the .dbschema file that you want to deploy or that you want to create when you import a schema. " />

    <columnDefinition name="SqlCmdVarsFile" type="string" length="0" modularize="property"
                      category="formatted" description="Specifies the name of the .sqlcmdvar file that you want to deploy or that you want to create when you import a schema. " />

    <columnDefinition name="PostDeploymentScript" type="string" length="0" modularize="property"
                      category="formatted" description="Specifies the name of the Post Deployment Script file." />
    
    <columnDefinition name="PreDeploymentScript" type="string" length="0" modularize="property"
                      category="formatted" description="Specifies the name of the Pre Deployment Script file." />
    
  </tableDefinition>
  
  <tableDefinition name="VsDbCmd10SqlCmdVariables" createSymbols="yes">
    <columnDefinition name="VsDbCmd10Id" type="string" length="72" modularize="column"
                          keyTable="VsDbCmd10" keyColumn="1" category="identifier" primaryKey="yes"
                          description="Foreign key into the VsDbCmd10 table used to determine install state" />

    <columnDefinition name="Name" type="string" length="0" modularize="property" primaryKey="yes"
                      category="formatted" description="Name of the SqlCmdVariable" />

    <columnDefinition name="Value" type="string" length="0" modularize="property"
                      category="formatted" description="Value of the SqlCmdVariable" />
  </tableDefinition>

  <tableDefinition name="SqlCmd" createSymbols="yes">
    <columnDefinition name="Id" type="string" length="72" primaryKey="yes" modularize="column"
                      description="Identifier for the SqlCmd." />
    
    <columnDefinition name="Component_" type="string" length="72" modularize="column"
                          keyTable="Component" keyColumn="1" category="identifier"
                          description="Foreign key into the Component table used to determine install state" />

    <columnDefinition name="ConnectionString" type="string" length="0" modularize="property"
                      category="formatted" description="Connection String of the Target Database" />

    <columnDefinition name="QueryType" type="number" length="4" 
                      description="Type of the Script 1 - File, 2 - Query" />

    <columnDefinition name="QueryString" type="string" length="0" modularize="property"
                      category="formatted" description="Script That needs to be executed" />

    <columnDefinition name="Sequence" type="number" length="4" modularize="column"
                      description="Sequence number" />

    <columnDefinition name="SqlCmdId" type="string" length="72" modularize="column"
                      description="Identifier for the SqlCmd." />

    <columnDefinition name="Condition" type="string" length="245" modularize="column" nullable="yes"
                      description="Condition to execute the script" />
    
  </tableDefinition>
    
  <tableDefinition name="SqlCmdVariables" createSymbols="yes">
    <columnDefinition name="SqlCmdId" type="string" length="72" modularize="column"
                      category="identifier" primaryKey="yes"
                      description="Foreign key into the SqlCmd table used to determine install state" />

    <columnDefinition name="Name" type="string" length="245" modularize="column" primaryKey="yes"
                      description="Name of the SqlCmdVariable" />

    <columnDefinition name="Value" type="string" length="0" modularize="property"
                      category="formatted" description="Value of the SqlCmdVariable" />
  </tableDefinition>
  
</tableDefinitions>
